Overview

Dataset statistics

Number of variables	35
Number of observations	86971
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	23.2 MiB
Average record size in memory	280.0 B

Variable types

Numeric	13
Text	10
Categorical	9
DateTime	3

Alerts

`address_id` is highly overall correlated with `customer_id` and 1 other fields	High correlation
`amount` is highly overall correlated with `rental_rate`	High correlation
`customer_id` is highly overall correlated with `address_id` and 1 other fields	High correlation
`film_id` is highly overall correlated with `inventory_id`	High correlation
`inventory_id` is highly overall correlated with `film_id`	High correlation
`payment_id` is highly overall correlated with `address_id` and 1 other fields	High correlation
`rental_rate` is highly overall correlated with `amount`	High correlation
`staff_fn` is highly overall correlated with `staff_id` and 2 other fields	High correlation
`staff_id` is highly overall correlated with `staff_fn` and 2 other fields	High correlation
`staff_ln` is highly overall correlated with `staff_fn` and 2 other fields	High correlation
`store_id` is highly overall correlated with `staff_fn` and 2 other fields	High correlation
`active` is highly imbalanced (82.7%)	Imbalance

Reproduction

Analysis started	2026-01-14 07:00:40.176811
Analysis finished	2026-01-14 07:00:54.499272
Duration	14.32 seconds
Software version	ydata-profiling vv4.18.1
Download configuration	config.json

film_id
Real number (ℝ)

High correlation

Distinct	955
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	502.29349

Minimum	1
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	679.6 KiB

Quantile statistics

Minimum	1
5-th percentile	48
Q1	256
median	496
Q3	752
95-th percentile	952
Maximum	1000
Range	999
Interquartile range (IQR)	496

Descriptive statistics

Standard deviation	288.20778
Coefficient of variation (CV)	0.57378364
Kurtosis	-1.1859664
Mean	502.29349
Median Absolute Deviation (MAD)	247
Skewness	-0.011599022
Sum	43684967
Variance	83063.727
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
489	279	0.3%
880	275	0.3%
249	273	0.3%
649	264	0.3%
892	252	0.3%
764	252	0.3%
418	248	0.3%
369	248	0.3%
301	243	0.3%
414	240	0.3%
Other values (945)	84397	97.0%

Value	Count	Frequency (%)
1	220	0.3%
2	24	< 0.1%
3	60	0.1%
4	110	0.1%
5	55	0.1%
6	147	0.2%
7	75	0.1%
8	72	0.1%
9	108	0.1%
10	184	0.2%

Value	Count	Frequency (%)
1000	93	0.1%
999	85	0.1%
998	48	0.1%
997	30	< 0.1%
996	35	< 0.1%
995	23	< 0.1%
994	78	0.1%
993	180	0.2%
992	56	0.1%
991	64	0.1%

title
Text

Distinct	955
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

Length

Max length	27
Median length	22
Mean length	14.315887
Min length	8

Characters and Unicode

Total characters	1245067
Distinct characters	27
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BLANKET BEVERLY
2nd row	BLANKET BEVERLY
3rd row	BLANKET BEVERLY
4th row	BLANKET BEVERLY
5th row	FREAKY POCUS

Value	Count	Frequency (%)
heartbreakers	659	0.4%
hellfighters	642	0.4%
armageddon	636	0.4%
boondock	631	0.4%
apollo	611	0.4%
polish	592	0.3%
desire	563	0.3%
shakespeare	562	0.3%
instinct	558	0.3%
love	548	0.3%
Other values (974)	167940	96.5%

Most occurring characters

Value	Count	Frequency (%)
E	123364	9.9%
A	105035	8.4%
R	91026	7.3%
O	87779	7.1%
	86971	7.0%
N	82351	6.6%
I	82017	6.6%
S	77792	6.2%
T	72061	5.8%
L	59662	4.8%
Other values (17)	377009	30.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1158096	93.0%
Space Separator	86971	7.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	123364	10.7%
A	105035	9.1%
R	91026	7.9%
O	87779	7.6%
N	82351	7.1%
I	82017	7.1%
S	77792	6.7%
T	72061	6.2%
L	59662	5.2%
C	47369	4.1%
Other values (16)	329640	28.5%

Space Separator

Value	Count	Frequency (%)
	86971	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1158096	93.0%
Common	86971	7.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	123364	10.7%
A	105035	9.1%
R	91026	7.9%
O	87779	7.6%
N	82351	7.1%
I	82017	7.1%
S	77792	6.7%
T	72061	6.2%
L	59662	5.2%
C	47369	4.1%
Other values (16)	329640	28.5%

Common

Value	Count	Frequency (%)
	86971	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1245067	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	123364	9.9%
A	105035	8.4%
R	91026	7.3%
O	87779	7.1%
	86971	7.0%
N	82351	6.6%
I	82017	6.6%
S	77792	6.2%
T	72061	5.8%
L	59662	4.8%
Other values (17)	377009	30.3%

description
Text

Distinct	955
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

Length

Max length	130
Median length	115
Mean length	94.315335
Min length	70

Characters and Unicode

Total characters	8202699
Distinct characters	52
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria
2nd row	A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria
3rd row	A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria
4th row	A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria
5th row	A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico

Value	Count	Frequency (%)
a	384073	24.0%
of	89982	5.6%
and	86971	5.4%
who	86971	5.4%
must	86971	5.4%
in	86971	5.4%
the	16699	1.0%
mad	15668	1.0%
shark	10557	0.7%
boat	10228	0.6%
Other values (139)	723265	45.3%

Most occurring characters

Value	Count	Frequency (%)
	1511385	18.4%
a	718977	8.8%
n	565473	6.9%
o	502463	6.1%
e	490408	6.0%
t	468027	5.7%
i	416232	5.1%
r	335873	4.1%
s	295545	3.6%
A	282804	3.4%
Other values (42)	2615512	31.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5657078	69.0%
Space Separator	1511385	18.4%
Uppercase Letter	1017316	12.4%
Dash Punctuation	16920	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	718977	12.7%
n	565473	10.0%
o	502463	8.9%
e	490408	8.7%
t	468027	8.3%
i	416232	7.4%
r	335873	5.9%
s	295545	5.2%
u	269218	4.8%
h	206132	3.6%
Other values (16)	1388730	24.5%

Uppercase Letter

Value	Count	Frequency (%)
A	282804	27.8%
S	101761	10.0%
C	84099	8.3%
M	68893	6.8%
D	60784	6.0%
B	58596	5.8%
T	56809	5.6%
F	56157	5.5%
P	46203	4.5%
W	32559	3.2%
Other values (14)	168651	16.6%

Space Separator

Value	Count	Frequency (%)
	1511385	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	16920	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6674394	81.4%
Common	1528305	18.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	718977	10.8%
n	565473	8.5%
o	502463	7.5%
e	490408	7.3%
t	468027	7.0%
i	416232	6.2%
r	335873	5.0%
s	295545	4.4%
A	282804	4.2%
u	269218	4.0%
Other values (40)	2329374	34.9%

Common

Value	Count	Frequency (%)
	1511385	98.9%
-	16920	1.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8202699	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1511385	18.4%
a	718977	8.8%
n	565473	6.9%
o	502463	6.1%
e	490408	6.0%
t	468027	5.7%
i	416232	5.1%
r	335873	4.1%
s	295545	3.6%
A	282804	3.4%
Other values (42)	2615512	31.9%

rental_duration
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

6	19042
4	18450
3	17938
5	17358
7	14183

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	86971
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	7
2nd row	7
3rd row	7
4th row	7
5th row	7

Common Values

Value	Count	Frequency (%)
6	19042	21.9%
4	18450	21.2%
3	17938	20.6%
5	17358	20.0%
7	14183	16.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
6	19042	21.9%
4	18450	21.2%
3	17938	20.6%
5	17358	20.0%
7	14183	16.3%

Most occurring characters

Value	Count	Frequency (%)
6	19042	21.9%
4	18450	21.2%
3	17938	20.6%
5	17358	20.0%
7	14183	16.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	86971	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
6	19042	21.9%
4	18450	21.2%
3	17938	20.6%
5	17358	20.0%
7	14183	16.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	86971	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
6	19042	21.9%
4	18450	21.2%
3	17938	20.6%
5	17358	20.0%
7	14183	16.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	86971	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
6	19042	21.9%
4	18450	21.2%
3	17938	20.6%
5	17358	20.0%
7	14183	16.3%

rental_rate
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

0.99	30746
2.99	28626
4.99	27599

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	347884
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2.99
2nd row	2.99
3rd row	2.99
4th row	2.99
5th row	2.99

Common Values

Value	Count	Frequency (%)
0.99	30746	35.4%
2.99	28626	32.9%
4.99	27599	31.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0.99	30746	35.4%
2.99	28626	32.9%
4.99	27599	31.7%

Most occurring characters

Value	Count	Frequency (%)
9	173942	50.0%
.	86971	25.0%
0	30746	8.8%
2	28626	8.2%
4	27599	7.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	260913	75.0%
Other Punctuation	86971	25.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
9	173942	66.7%
0	30746	11.8%
2	28626	11.0%
4	27599	10.6%

Other Punctuation

Value	Count	Frequency (%)
.	86971	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	347884	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
9	173942	50.0%
.	86971	25.0%
0	30746	8.8%
2	28626	8.2%
4	27599	7.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	347884	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
9	173942	50.0%
.	86971	25.0%
0	30746	8.8%
2	28626	8.2%
4	27599	7.9%

length
Real number (ℝ)

Distinct	140
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	115.15425

Minimum	46
Maximum	185
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	679.6 KiB

Quantile statistics

Minimum	46
5-th percentile	52
Q1	80
median	114
Q3	150
95-th percentile	178
Maximum	185
Range	139
Interquartile range (IQR)	70

Descriptive statistics

Standard deviation	40.508461
Coefficient of variation (CV)	0.35177566
Kurtosis	-1.1983035
Mean	115.15425
Median Absolute Deviation (MAD)	35
Skewness	0.026121438
Sum	10015080
Variance	1640.9354
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
85	1465	1.7%
178	1352	1.6%
112	1345	1.5%
84	1178	1.4%
80	1062	1.2%
63	1062	1.2%
75	1056	1.2%
92	1028	1.2%
179	1008	1.2%
161	1000	1.1%
Other values (130)	75415	86.7%

Value	Count	Frequency (%)
46	580	0.7%
47	724	0.8%
48	828	1.0%
49	351	0.4%
50	557	0.6%
51	631	0.7%
52	682	0.8%
53	743	0.9%
54	515	0.6%
55	336	0.4%

Value	Count	Frequency (%)
185	936	1.1%
184	366	0.4%
183	417	0.5%
182	251	0.3%
181	817	0.9%
180	376	0.4%
179	1008	1.2%
178	1352	1.6%
177	660	0.8%
176	885	1.0%

replacement_cost
Real number (ℝ)

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.199909

Minimum	9.99
Maximum	29.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	679.6 KiB

Quantile statistics

Minimum	9.99
5-th percentile	10.99
Q1	14.99
median	20.99
Q3	25.99
95-th percentile	29.99
Maximum	29.99
Range	20
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	6.0907494
Coefficient of variation (CV)	0.3015236
Kurtosis	-1.2239214
Mean	20.199909
Median Absolute Deviation (MAD)	6
Skewness	-0.037070367
Sum	1756806.3
Variance	37.097228
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
22.99	5561	6.4%
27.99	5168	5.9%
12.99	4964	5.7%
21.99	4845	5.6%
14.99	4818	5.5%
29.99	4660	5.4%
20.99	4620	5.3%
26.99	4226	4.9%
13.99	4146	4.8%
11.99	4100	4.7%
Other values (11)	39863	45.8%

Value	Count	Frequency (%)
9.99	3888	4.5%
10.99	3482	4.0%
11.99	4100	4.7%
12.99	4964	5.7%
13.99	4146	4.8%
14.99	4818	5.5%
15.99	3123	3.6%
16.99	3557	4.1%
17.99	3692	4.2%
18.99	3661	4.2%

Value	Count	Frequency (%)
29.99	4660	5.4%
28.99	4046	4.7%
27.99	5168	5.9%
26.99	4226	4.9%
25.99	3668	4.2%
24.99	3383	3.9%
23.99	3835	4.4%
22.99	5561	6.4%
21.99	4845	5.6%
20.99	4620	5.3%

rating
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

PG-13	18850
PG	18411
NC-17	17388
R	17053
G	15269

Length

Max length	5
Median length	2
Mean length	2.8783618
Min length	1

Characters and Unicode

Total characters	250334
Distinct characters	9
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	G
2nd row	G
3rd row	G
4th row	G
5th row	R

Common Values

Value	Count	Frequency (%)
PG-13	18850	21.7%
PG	18411	21.2%
NC-17	17388	20.0%
R	17053	19.6%
G	15269	17.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pg-13	18850	21.7%
pg	18411	21.2%
nc-17	17388	20.0%
r	17053	19.6%
g	15269	17.6%

Most occurring characters

Value	Count	Frequency (%)
G	52530	21.0%
P	37261	14.9%
-	36238	14.5%
1	36238	14.5%
3	18850	7.5%
N	17388	6.9%
C	17388	6.9%
7	17388	6.9%
R	17053	6.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	141620	56.6%
Decimal Number	72476	29.0%
Dash Punctuation	36238	14.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
G	52530	37.1%
P	37261	26.3%
N	17388	12.3%
C	17388	12.3%
R	17053	12.0%

Decimal Number

Value	Count	Frequency (%)
1	36238	50.0%
3	18850	26.0%
7	17388	24.0%

Dash Punctuation

Value	Count	Frequency (%)
-	36238	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	141620	56.6%
Common	108714	43.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
G	52530	37.1%
P	37261	26.3%
N	17388	12.3%
C	17388	12.3%
R	17053	12.0%

Common

Value	Count	Frequency (%)
-	36238	33.3%
1	36238	33.3%
3	18850	17.3%
7	17388	16.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	250334	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
G	52530	21.0%
P	37261	14.9%
-	36238	14.5%
1	36238	14.5%
3	18850	7.5%
N	17388	6.9%
C	17388	6.9%
7	17388	6.9%
R	17053	6.8%

actor_id
Real number (ℝ)

Distinct	200
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	100.9395

Minimum	1
Maximum	200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	679.6 KiB

Quantile statistics

Minimum	1
5-th percentile	12
Q1	52
median	102
Q3	149
95-th percentile	191
Maximum	200
Range	199
Interquartile range (IQR)	97

Descriptive statistics

Standard deviation	56.883288
Coefficient of variation (CV)	0.56353845
Kurtosis	-1.1741743
Mean	100.9395
Median Absolute Deviation (MAD)	48
Skewness	0.0025358136
Sum	8778809
Variance	3235.7084
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
107	742	0.9%
181	664	0.8%
198	663	0.8%
144	645	0.7%
102	632	0.7%
60	608	0.7%
150	602	0.7%
37	598	0.7%
23	593	0.7%
90	588	0.7%
Other values (190)	80636	92.7%

Value	Count	Frequency (%)
1	301	0.3%
2	384	0.4%
3	308	0.4%
4	272	0.3%
5	490	0.6%
6	273	0.3%
7	476	0.5%
8	314	0.4%
9	376	0.4%
10	355	0.4%

Value	Count	Frequency (%)
200	339	0.4%
199	248	0.3%
198	663	0.8%
197	546	0.6%
196	450	0.5%
195	443	0.5%
194	378	0.4%
193	438	0.5%
192	452	0.5%
191	515	0.6%

actor_fn
Text

Distinct	128
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

Length

Max length	11
Median length	8
Mean length	5.3014798
Min length	2

Characters and Unicode

Total characters	461075
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FRED
2nd row	ALAN
3rd row	BURT
4th row	THORA
5th row	TOM

Value	Count	Frequency (%)
penelope	1637	1.9%
kenneth	1625	1.9%
jayne	1544	1.8%
matthew	1496	1.7%
julia	1414	1.6%
groucho	1333	1.5%
morgan	1322	1.5%
ed	1295	1.5%
burt	1291	1.5%
christian	1271	1.5%
Other values (118)	72743	83.6%

Most occurring characters

Value	Count	Frequency (%)
E	64486	14.0%
A	52085	11.3%
R	40638	8.8%
N	40267	8.7%
L	29241	6.3%
I	29081	6.3%
O	18393	4.0%
S	18364	4.0%
T	17941	3.9%
C	17009	3.7%
Other values (14)	133570	29.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	461075	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	64486	14.0%
A	52085	11.3%
R	40638	8.8%
N	40267	8.7%
L	29241	6.3%
I	29081	6.3%
O	18393	4.0%
S	18364	4.0%
T	17941	3.9%
C	17009	3.7%
Other values (14)	133570	29.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	461075	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	64486	14.0%
A	52085	11.3%
R	40638	8.8%
N	40267	8.7%
L	29241	6.3%
I	29081	6.3%
O	18393	4.0%
S	18364	4.0%
T	17941	3.9%
C	17009	3.7%
Other values (14)	133570	29.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	461075	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	64486	14.0%
A	52085	11.3%
R	40638	8.8%
N	40267	8.7%
L	29241	6.3%
I	29081	6.3%
O	18393	4.0%
S	18364	4.0%
T	17941	3.9%
C	17009	3.7%
Other values (14)	133570	29.0%

actor_ln
Text

Distinct	121
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

Length

Max length	12
Median length	9
Mean length	6.2449207
Min length	3

Characters and Unicode

Total characters	543127
Distinct characters	27
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	COSTNER
2nd row	DREYFUSS
3rd row	TEMPLE
4th row	TEMPLE
5th row	MIRANDA

Value	Count	Frequency (%)
kilmer	2124	2.4%
nolte	2090	2.4%
temple	1756	2.0%
degeneres	1593	1.8%
keitel	1564	1.8%
berry	1464	1.7%
torn	1459	1.7%
hoffman	1444	1.7%
guiness	1407	1.6%
garland	1379	1.6%
Other values (111)	70691	81.3%

Most occurring characters

Value	Count	Frequency (%)
E	67826	12.5%
N	44339	8.2%
R	40636	7.5%
A	39274	7.2%
O	39205	7.2%
L	39012	7.2%
I	33562	6.2%
S	31932	5.9%
T	23352	4.3%
D	21252	3.9%
Other values (17)	162737	30.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	542645	99.9%
Dash Punctuation	482	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	67826	12.5%
N	44339	8.2%
R	40636	7.5%
A	39274	7.2%
O	39205	7.2%
L	39012	7.2%
I	33562	6.2%
S	31932	5.9%
T	23352	4.3%
D	21252	3.9%
Other values (16)	162255	29.9%

Dash Punctuation

Value	Count	Frequency (%)
-	482	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	542645	99.9%
Common	482	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	67826	12.5%
N	44339	8.2%
R	40636	7.5%
A	39274	7.2%
O	39205	7.2%
L	39012	7.2%
I	33562	6.2%
S	31932	5.9%
T	23352	4.3%
D	21252	3.9%
Other values (16)	162255	29.9%

Common

Value	Count	Frequency (%)
-	482	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	543127	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	67826	12.5%
N	44339	8.2%
R	40636	7.5%
A	39274	7.2%
O	39205	7.2%
L	39012	7.2%
I	33562	6.2%
S	31932	5.9%
T	23352	4.3%
D	21252	3.9%
Other values (17)	162737	30.0%

customer_id
Real number (ℝ)

High correlation

Distinct	599
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	297.3076

Minimum	1
Maximum	599
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	679.6 KiB

Quantile statistics

Minimum	1
5-th percentile	29
Q1	148
median	296
Q3	446
95-th percentile	568
Maximum	599
Range	598
Interquartile range (IQR)	298

Descriptive statistics

Standard deviation	172.18532
Coefficient of variation (CV)	0.57914873
Kurtosis	-1.1879078
Mean	297.3076
Median Absolute Deviation (MAD)	149
Skewness	0.0073978278
Sum	25857139
Variance	29647.783
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
148	272	0.3%
526	251	0.3%
197	244	0.3%
144	239	0.3%
236	225	0.3%
257	221	0.3%
29	217	0.2%
178	217	0.2%
75	212	0.2%
506	211	0.2%
Other values (589)	84662	97.3%

Value	Count	Frequency (%)
1	156	0.2%
2	175	0.2%
3	144	0.2%
4	121	0.1%
5	175	0.2%
6	171	0.2%
7	191	0.2%
8	152	0.2%
9	122	0.1%
10	123	0.1%

Value	Count	Frequency (%)
599	102	0.1%
598	102	0.1%
597	139	0.2%
596	154	0.2%
595	141	0.2%
594	141	0.2%
593	129	0.1%
592	139	0.2%
591	120	0.1%
590	129	0.1%

cust_fn
Text

Distinct	591
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

Length

Max length	11
Median length	10
Mean length	5.6722471
Min length	2

Characters and Unicode

Total characters	493321
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CHARLOTTE
2nd row	CHARLOTTE
3rd row	CHARLOTTE
4th row	CHARLOTTE
5th row	TOMMY

Value	Count	Frequency (%)
marion	385	0.4%
leslie	325	0.4%
tracy	298	0.3%
terry	282	0.3%
willie	280	0.3%
jamie	277	0.3%
jessie	276	0.3%
eleanor	272	0.3%
kelly	272	0.3%
karl	251	0.3%
Other values (581)	84053	96.6%

Most occurring characters

Value	Count	Frequency (%)
E	62268	12.6%
A	60578	12.3%
R	46544	9.4%
N	42296	8.6%
I	38227	7.7%
L	36270	7.4%
O	23170	4.7%
T	21174	4.3%
S	19394	3.9%
D	18697	3.8%
Other values (16)	124703	25.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	493321	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	62268	12.6%
A	60578	12.3%
R	46544	9.4%
N	42296	8.6%
I	38227	7.7%
L	36270	7.4%
O	23170	4.7%
T	21174	4.3%
S	19394	3.9%
D	18697	3.8%
Other values (16)	124703	25.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	493321	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	62268	12.6%
A	60578	12.3%
R	46544	9.4%
N	42296	8.6%
I	38227	7.7%
L	36270	7.4%
O	23170	4.7%
T	21174	4.3%
S	19394	3.9%
D	18697	3.8%
Other values (16)	124703	25.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	493321	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	62268	12.6%
A	60578	12.3%
R	46544	9.4%
N	42296	8.6%
I	38227	7.7%
L	36270	7.4%
O	23170	4.7%
T	21174	4.3%
S	19394	3.9%
D	18697	3.8%
Other values (16)	124703	25.3%

cust_ln
Text

Distinct	599
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

Length

Max length	12
Median length	10
Mean length	6.1929609
Min length	2

Characters and Unicode

Total characters	538608
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HUNTER
2nd row	HUNTER
3rd row	HUNTER
4th row	HUNTER
5th row	COLLAZO

Value	Count	Frequency (%)
hunt	272	0.3%
seal	251	0.3%
peters	244	0.3%
shaw	239	0.3%
dean	225	0.3%
douglas	221	0.3%
hernandez	217	0.2%
snyder	217	0.2%
sanders	212	0.2%
seward	211	0.2%
Other values (589)	84662	97.3%

Most occurring characters

Value	Count	Frequency (%)
E	57552	10.7%
R	53721	10.0%
A	46896	8.7%
N	42993	8.0%
O	38448	7.1%
L	38183	7.1%
S	35551	6.6%
I	26602	4.9%
T	25723	4.8%
H	19807	3.7%
Other values (16)	153132	28.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	538608	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	57552	10.7%
R	53721	10.0%
A	46896	8.7%
N	42993	8.0%
O	38448	7.1%
L	38183	7.1%
S	35551	6.6%
I	26602	4.9%
T	25723	4.8%
H	19807	3.7%
Other values (16)	153132	28.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	538608	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	57552	10.7%
R	53721	10.0%
A	46896	8.7%
N	42993	8.0%
O	38448	7.1%
L	38183	7.1%
S	35551	6.6%
I	26602	4.9%
T	25723	4.8%
H	19807	3.7%
Other values (16)	153132	28.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	538608	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	57552	10.7%
R	53721	10.0%
A	46896	8.7%
N	42993	8.0%
O	38448	7.1%
L	38183	7.1%
S	35551	6.6%
I	26602	4.9%
T	25723	4.8%
H	19807	3.7%
Other values (16)	153132	28.4%

email
Text

Distinct	599
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

Length

Max length	40
Median length	38
Mean length	31.865208
Min length	26

Characters and Unicode

Total characters	2771349
Distinct characters	41
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CHARLOTTE.HUNTER@sakilacustomer.org
2nd row	CHARLOTTE.HUNTER@sakilacustomer.org
3rd row	CHARLOTTE.HUNTER@sakilacustomer.org
4th row	CHARLOTTE.HUNTER@sakilacustomer.org
5th row	TOMMY.COLLAZO@sakilacustomer.org

Value	Count	Frequency (%)
eleanor.hunt@sakilacustomer.org	272	0.3%
karl.seal@sakilacustomer.org	251	0.3%
sue.peters@sakilacustomer.org	244	0.3%
clara.shaw@sakilacustomer.org	239	0.3%
marcia.dean@sakilacustomer.org	225	0.3%
marsha.douglas@sakilacustomer.org	221	0.3%
angela.hernandez@sakilacustomer.org	217	0.2%
marion.snyder@sakilacustomer.org	217	0.2%
tammy.sanders@sakilacustomer.org	212	0.2%
leslie.seward@sakilacustomer.org	211	0.2%
Other values (589)	84662	97.3%

Most occurring characters

Value	Count	Frequency (%)
r	173942	6.3%
.	173942	6.3%
o	173942	6.3%
s	173942	6.3%
a	173942	6.3%
E	119820	4.3%
A	107474	3.9%
R	100265	3.6%
l	86971	3.1%
g	86971	3.1%
Other values (31)	1400138	50.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1478507	53.3%
Uppercase Letter	1031929	37.2%
Other Punctuation	260913	9.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	119820	11.6%
A	107474	10.4%
R	100265	9.7%
N	85289	8.3%
L	74453	7.2%
I	64829	6.3%
O	61618	6.0%
S	54945	5.3%
T	46897	4.5%
C	35920	3.5%
Other values (16)	280419	27.2%

Lowercase Letter

Value	Count	Frequency (%)
r	173942	11.8%
o	173942	11.8%
s	173942	11.8%
a	173942	11.8%
l	86971	5.9%
g	86971	5.9%
e	86971	5.9%
t	86971	5.9%
u	86971	5.9%
c	86971	5.9%
Other values (3)	260913	17.6%

Other Punctuation

Value	Count	Frequency (%)
.	173942	66.7%
@	86971	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2510436	90.6%
Common	260913	9.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	173942	6.9%
o	173942	6.9%
s	173942	6.9%
a	173942	6.9%
E	119820	4.8%
A	107474	4.3%
R	100265	4.0%
l	86971	3.5%
g	86971	3.5%
e	86971	3.5%
Other values (29)	1226196	48.8%

Common

Value	Count	Frequency (%)
.	173942	66.7%
@	86971	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2771349	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	173942	6.3%
.	173942	6.3%
o	173942	6.3%
s	173942	6.3%
a	173942	6.3%
E	119820	4.3%
A	107474	3.9%
R	100265	3.6%
l	86971	3.1%
g	86971	3.1%
Other values (31)	1400138	50.5%

active
Categorical

Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

1	84729
0	2242

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	86971
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	84729	97.4%
0	2242	2.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	84729	97.4%
0	2242	2.6%

Most occurring characters

Value	Count	Frequency (%)
1	84729	97.4%
0	2242	2.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	86971	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	84729	97.4%
0	2242	2.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	86971	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	84729	97.4%
0	2242	2.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	86971	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	84729	97.4%
0	2242	2.6%

rental_id
Real number (ℝ)

Distinct	15821
Distinct (%)	18.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7969.3271

Minimum	1
Maximum	16049
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	679.6 KiB

Quantile statistics

Minimum	1
5-th percentile	811
Q1	3983
median	7948
Q3	11918.5
95-th percentile	15222.5
Maximum	16049
Range	16048
Interquartile range (IQR)	7935.5

Descriptive statistics

Standard deviation	4615.1429
Coefficient of variation (CV)	0.57911325
Kurtosis	-1.1897433
Mean	7969.3271
Median Absolute Deviation (MAD)	3968
Skewness	0.016729421
Sum	6.9310035 × 10⁸
Variance	21299544
Monotonicity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12701	15	< 0.1%
8014	15	< 0.1%
4845	15	< 0.1%
15187	15	< 0.1%
14200	15	< 0.1%
5221	15	< 0.1%
2796	15	< 0.1%
5930	15	< 0.1%
7446	15	< 0.1%
7152	15	< 0.1%
Other values (15811)	86821	99.8%

Value	Count	Frequency (%)
1	4	< 0.1%
2	5	< 0.1%
3	2	< 0.1%
4	4	< 0.1%
5	8	< 0.1%
6	4	< 0.1%
7	6	< 0.1%
8	4	< 0.1%
9	3	< 0.1%
10	7	< 0.1%

Value	Count	Frequency (%)
16049	6	< 0.1%
16048	2	< 0.1%
16047	7	< 0.1%
16046	5	< 0.1%
16045	5	< 0.1%
16044	5	< 0.1%
16043	7	< 0.1%
16042	3	< 0.1%
16041	6	< 0.1%
16040	8	< 0.1%

rental_date
Date

Distinct	15774
Distinct (%)	18.1%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

Minimum	2005-05-24 22:53:30
Maximum	2005-08-23 22:50:12
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

return_date
Date

Distinct	15796
Distinct (%)	18.2%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

Minimum	2005-05-25 23:55:21
Maximum	2005-09-02 02:35:22
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

payment_id
Real number (ℝ)

High correlation

Distinct	15821
Distinct (%)	18.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8028.9088

Minimum	1
Maximum	16049
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	679.6 KiB

Quantile statistics

Minimum	1
5-th percentile	798
Q1	4038
median	8040
Q3	12028
95-th percentile	15217
Maximum	16049
Range	16048
Interquartile range (IQR)	7990

Descriptive statistics

Standard deviation	4625.7166
Coefficient of variation (CV)	0.57613266
Kurtosis	-1.1973239
Mean	8028.9088
Median Absolute Deviation (MAD)	3994
Skewness	-0.0075447733
Sum	6.9828223 × 10⁸
Variance	21397254
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13202	15	< 0.1%
288	15	< 0.1%
14839	15	< 0.1%
12463	15	< 0.1%
9457	15	< 0.1%
2280	15	< 0.1%
5662	15	< 0.1%
6853	15	< 0.1%
13129	15	< 0.1%
10004	15	< 0.1%
Other values (15811)	86821	99.8%

Value	Count	Frequency (%)
1	4	< 0.1%
2	5	< 0.1%
3	1	< 0.1%
4	3	< 0.1%
5	1	< 0.1%
6	6	< 0.1%
7	4	< 0.1%
8	6	< 0.1%
9	5	< 0.1%
10	5	< 0.1%

Value	Count	Frequency (%)
16049	4	< 0.1%
16048	8	< 0.1%
16047	5	< 0.1%
16046	4	< 0.1%
16045	3	< 0.1%
16044	5	< 0.1%
16043	3	< 0.1%
16042	5	< 0.1%
16041	9	< 0.1%
16040	6	< 0.1%

amount
Real number (ℝ)

High correlation

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.1929297

Minimum	0.99
Maximum	11.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	679.6 KiB

Quantile statistics

Minimum	0.99
5-th percentile	0.99
Q1	2.99
median	3.99
Q3	4.99
95-th percentile	8.99
Maximum	11.99
Range	11
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.3424864
Coefficient of variation (CV)	0.55867534
Kurtosis	-0.24019559
Mean	4.1929297
Median Absolute Deviation (MAD)	1
Skewness	0.47005036
Sum	364663.29
Variance	5.4872427
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
4.99	20213	23.2%
2.99	19666	22.6%
0.99	15965	18.4%
5.99	7181	8.3%
3.99	6340	7.3%
6.99	5929	6.8%
7.99	3654	4.2%
1.99	3490	4.0%
8.99	2633	3.0%
9.99	1302	1.5%
Other values (2)	598	0.7%

Value	Count	Frequency (%)
0.99	15965	18.4%
1.99	3490	4.0%
2.99	19666	22.6%
3.99	6340	7.3%
4.99	20213	23.2%
5.99	7181	8.3%
6.99	5929	6.8%
7.99	3654	4.2%
8.99	2633	3.0%
9.99	1302	1.5%

Value	Count	Frequency (%)
11.99	49	0.1%
10.99	549	0.6%
9.99	1302	1.5%
8.99	2633	3.0%
7.99	3654	4.2%
6.99	5929	6.8%
5.99	7181	8.3%
4.99	20213	23.2%
3.99	6340	7.3%
2.99	19666	22.6%

payment_date
Date

Distinct	15774
Distinct (%)	18.1%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

Minimum	2005-05-24 22:53:30
Maximum	2005-08-23 22:50:12
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

inventory_id
Real number (ℝ)

High correlation

Distinct	4567
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2297.3186

Minimum	1
Maximum	4581
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	679.6 KiB

Quantile statistics

Minimum	1
5-th percentile	214
Q1	1160
median	2289
Q3	3428
95-th percentile	4368
Maximum	4581
Range	4580
Interquartile range (IQR)	2268

Descriptive statistics

Standard deviation	1320.7305
Coefficient of variation (CV)	0.57490088
Kurtosis	-1.1807221
Mean	2297.3186
Median Absolute Deviation (MAD)	1132
Skewness	-0.0074845396
Sum	1.9980009 × 10⁸
Variance	1744329
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1122	65	0.1%
1123	65	0.1%
2424	60	0.1%
158	60	0.1%
2423	60	0.1%
1899	60	0.1%
4095	60	0.1%
2371	60	0.1%
2337	60	0.1%
2963	55	0.1%
Other values (4557)	86366	99.3%

Value	Count	Frequency (%)
1	30	< 0.1%
2	50	0.1%
3	20	< 0.1%
4	20	< 0.1%
6	40	< 0.1%
7	40	< 0.1%
8	20	< 0.1%
9	4	< 0.1%
10	12	< 0.1%
11	8	< 0.1%

Value	Count	Frequency (%)
4581	15	< 0.1%
4580	6	< 0.1%
4579	15	< 0.1%
4578	9	< 0.1%
4577	15	< 0.1%
4576	12	< 0.1%
4575	12	< 0.1%
4574	9	< 0.1%
4573	25	< 0.1%
4572	20	< 0.1%

store_id
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

1	47427
2	39544

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	86971
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	47427	54.5%
2	39544	45.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	47427	54.5%
2	39544	45.5%

Most occurring characters

Value	Count	Frequency (%)
1	47427	54.5%
2	39544	45.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	86971	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	47427	54.5%
2	39544	45.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	86971	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	47427	54.5%
2	39544	45.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	86971	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	47427	54.5%
2	39544	45.5%

staff_id
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

1	47427
2	39544

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	86971
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	47427	54.5%
2	39544	45.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	47427	54.5%
2	39544	45.5%

Most occurring characters

Value	Count	Frequency (%)
1	47427	54.5%
2	39544	45.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	86971	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	47427	54.5%
2	39544	45.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	86971	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	47427	54.5%
2	39544	45.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	86971	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	47427	54.5%
2	39544	45.5%

staff_fn
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

Mike	47427
Jon	39544

Length

Max length	4
Median length	4
Mean length	3.5453197
Min length	3

Characters and Unicode

Total characters	308340
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mike
2nd row	Mike
3rd row	Mike
4th row	Mike
5th row	Mike

Common Values

Value	Count	Frequency (%)
Mike	47427	54.5%
Jon	39544	45.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
mike	47427	54.5%
jon	39544	45.5%

Most occurring characters

Value	Count	Frequency (%)
M	47427	15.4%
i	47427	15.4%
k	47427	15.4%
e	47427	15.4%
J	39544	12.8%
o	39544	12.8%
n	39544	12.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	221369	71.8%
Uppercase Letter	86971	28.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	47427	21.4%
k	47427	21.4%
e	47427	21.4%
o	39544	17.9%
n	39544	17.9%

Uppercase Letter

Value	Count	Frequency (%)
M	47427	54.5%
J	39544	45.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	308340	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
M	47427	15.4%
i	47427	15.4%
k	47427	15.4%
e	47427	15.4%
J	39544	12.8%
o	39544	12.8%
n	39544	12.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	308340	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
M	47427	15.4%
i	47427	15.4%
k	47427	15.4%
e	47427	15.4%
J	39544	12.8%
o	39544	12.8%
n	39544	12.8%

staff_ln
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

Hillyer	47427
Stephens	39544

Length

Max length	8
Median length	7
Mean length	7.4546803
Min length	7

Characters and Unicode

Total characters	648341
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Hillyer
2nd row	Hillyer
3rd row	Hillyer
4th row	Hillyer
5th row	Hillyer

Common Values

Value	Count	Frequency (%)
Hillyer	47427	54.5%
Stephens	39544	45.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
hillyer	47427	54.5%
stephens	39544	45.5%

Most occurring characters

Value	Count	Frequency (%)
e	126515	19.5%
l	94854	14.6%
H	47427	7.3%
i	47427	7.3%
y	47427	7.3%
r	47427	7.3%
S	39544	6.1%
t	39544	6.1%
p	39544	6.1%
h	39544	6.1%
Other values (2)	79088	12.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	561370	86.6%
Uppercase Letter	86971	13.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	126515	22.5%
l	94854	16.9%
i	47427	8.4%
y	47427	8.4%
r	47427	8.4%
t	39544	7.0%
p	39544	7.0%
h	39544	7.0%
n	39544	7.0%
s	39544	7.0%

Uppercase Letter

Value	Count	Frequency (%)
H	47427	54.5%
S	39544	45.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	648341	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	126515	19.5%
l	94854	14.6%
H	47427	7.3%
i	47427	7.3%
y	47427	7.3%
r	47427	7.3%
S	39544	6.1%
t	39544	6.1%
p	39544	6.1%
h	39544	6.1%
Other values (2)	79088	12.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	648341	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	126515	19.5%
l	94854	14.6%
H	47427	7.3%
i	47427	7.3%
y	47427	7.3%
r	47427	7.3%
S	39544	6.1%
t	39544	6.1%
p	39544	6.1%
h	39544	6.1%
Other values (2)	79088	12.2%

address_id
Real number (ℝ)

High correlation

Distinct	599
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	302.02316

Minimum	5
Maximum	605
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	679.6 KiB

Quantile statistics

Minimum	5
5-th percentile	33
Q1	152
median	301
Q3	451
95-th percentile	574
Maximum	605
Range	600
Interquartile range (IQR)	299

Descriptive statistics

Standard deviation	172.81561
Coefficient of variation (CV)	0.57219324
Kurtosis	-1.1881586
Mean	302.02316
Median Absolute Deviation (MAD)	149
Skewness	0.0090934767
Sum	26267256
Variance	29865.234
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
152	272	0.3%
532	251	0.3%
201	244	0.3%
148	239	0.3%
240	225	0.3%
262	221	0.3%
33	217	0.2%
182	217	0.2%
79	212	0.2%
511	211	0.2%
Other values (589)	84662	97.3%

Value	Count	Frequency (%)
5	156	0.2%
6	175	0.2%
7	144	0.2%
8	121	0.1%
9	175	0.2%
10	171	0.2%
11	191	0.2%
12	152	0.2%
13	122	0.1%
14	123	0.1%

Value	Count	Frequency (%)
605	102	0.1%
604	102	0.1%
603	139	0.2%
602	154	0.2%
601	141	0.2%
600	141	0.2%
599	129	0.1%
598	139	0.2%
597	120	0.1%
596	129	0.1%

address
Text

Distinct	599
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

Length

Max length	38
Median length	34
Mean length	19.466282
Min length	9

Characters and Unicode

Total characters	1693002
Distinct characters	66
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	758 Junan Lane
2nd row	758 Junan Lane
3rd row	758 Junan Lane
4th row	758 Junan Lane
5th row	76 Kermanshah Manor

Value	Count	Frequency (%)
parkway	10989	3.8%
manor	9773	3.4%
avenue	8832	3.1%
way	8767	3.1%
lane	8635	3.0%
street	8561	3.0%
place	8117	2.8%
loop	7980	2.8%
boulevard	7724	2.7%
drive	7593	2.7%
Other values (957)	198978	69.6%

Most occurring characters

Value	Count	Frequency (%)
	198978	11.8%
a	176965	10.5%
e	108940	6.4%
o	86169	5.1%
r	82593	4.9%
n	81151	4.8%
1	66932	4.0%
i	50997	3.0%
l	50634	3.0%
u	48441	2.9%
Other values (56)	741202	43.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	993631	58.7%
Decimal Number	296082	17.5%
Space Separator	198978	11.8%
Uppercase Letter	196522	11.6%
Dash Punctuation	3471	0.2%
Open Punctuation	2159	0.1%
Close Punctuation	2159	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	176965	17.8%
e	108940	11.0%
o	86169	8.7%
r	82593	8.3%
n	81151	8.2%
i	50997	5.1%
l	50634	5.1%
u	48441	4.9%
t	40896	4.1%
y	29143	2.9%
Other values (16)	237702	23.9%

Uppercase Letter

Value	Count	Frequency (%)
P	26280	13.4%
L	21774	11.1%
S	21644	11.0%
B	18284	9.3%
A	17157	8.7%
M	15102	7.7%
D	10399	5.3%
W	9368	4.8%
C	9033	4.6%
T	6459	3.3%
Other values (16)	41022	20.9%

Decimal Number

Value	Count	Frequency (%)
1	66932	22.6%
6	29227	9.9%
4	28644	9.7%
9	27998	9.5%
7	26263	8.9%
8	25982	8.8%
5	24591	8.3%
2	24226	8.2%
3	23063	7.8%
0	19156	6.5%

Space Separator

Value	Count	Frequency (%)
	198978	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3471	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2159	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2159	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1190153	70.3%
Common	502849	29.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	176965	14.9%
e	108940	9.2%
o	86169	7.2%
r	82593	6.9%
n	81151	6.8%
i	50997	4.3%
l	50634	4.3%
u	48441	4.1%
t	40896	3.4%
y	29143	2.4%
Other values (42)	434224	36.5%

Common

Value	Count	Frequency (%)
	198978	39.6%
1	66932	13.3%
6	29227	5.8%
4	28644	5.7%
9	27998	5.6%
7	26263	5.2%
8	25982	5.2%
5	24591	4.9%
2	24226	4.8%
3	23063	4.6%
Other values (4)	26945	5.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1693002	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	198978	11.8%
a	176965	10.5%
e	108940	6.4%
o	86169	5.1%
r	82593	4.9%
n	81151	4.8%
1	66932	4.0%
i	50997	3.0%
l	50634	3.0%
u	48441	2.9%
Other values (56)	741202	43.8%

postal_code
Real number (ℝ)

Distinct	596
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	50317.771

Minimum	3
Maximum	99865
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	679.6 KiB

Quantile statistics

Minimum	3
5-th percentile	4855
Q1	25220
median	50805
Q3	74750
95-th percentile	95509
Maximum	99865
Range	99862
Interquartile range (IQR)	49530

Descriptive statistics

Standard deviation	28850.283
Coefficient of variation (CV)	0.57336171
Kurtosis	-1.1649044
Mean	50317.771
Median Absolute Deviation (MAD)	24704
Skewness	-0.017702468
Sum	4.3761869 × 10⁹
Variance	8.3233886 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
52137	294	0.3%
9668	284	0.3%
92150	272	0.3%
22474	270	0.3%
31342	251	0.3%
89459	244	0.3%
30861	239	0.3%
18727	225	0.3%
86768	221	0.3%
65750	217	0.2%
Other values (586)	84454	97.1%

Value	Count	Frequency (%)
3	116	0.1%
400	138	0.2%
504	130	0.1%
841	101	0.1%
943	133	0.2%
966	114	0.1%
1027	124	0.1%
1079	122	0.1%
1195	146	0.2%
1545	190	0.2%

Value	Count	Frequency (%)
99865	126	0.1%
99780	165	0.2%
99552	140	0.2%
99457	168	0.2%
99405	178	0.2%
99124	119	0.1%
98889	141	0.2%
98883	157	0.2%
98775	121	0.1%
98573	148	0.2%

city_id
Real number (ℝ)

Distinct	597
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	301.5238

Minimum	1
Maximum	600
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	679.6 KiB

Quantile statistics

Minimum	1
5-th percentile	31
Q1	148
median	305
Q3	452
95-th percentile	569
Maximum	600
Range	599
Interquartile range (IQR)	304

Descriptive statistics

Standard deviation	173.42494
Coefficient of variation (CV)	0.5751617
Kurtosis	-1.2093799
Mean	301.5238
Median Absolute Deviation (MAD)	151
Skewness	-0.016446523
Sum	26223826
Variance	30076.209
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
442	272	0.3%
42	263	0.3%
312	258	0.3%
101	251	0.3%
109	244	0.3%
340	239	0.3%
527	225	0.3%
64	221	0.3%
474	217	0.2%
456	217	0.2%
Other values (587)	84564	97.2%

Value	Count	Frequency (%)
1	153	0.2%
2	120	0.1%
3	175	0.2%
4	160	0.2%
5	124	0.1%
6	123	0.1%
7	178	0.2%
8	136	0.2%
9	164	0.2%
10	157	0.2%

Value	Count	Frequency (%)
600	131	0.2%
599	162	0.2%
598	157	0.2%
597	138	0.2%
596	153	0.2%
595	81	0.1%
594	123	0.1%
593	144	0.2%
592	139	0.2%
591	124	0.1%

city
Text

Distinct	597
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

Length

Max length	26
Median length	21
Mean length	8.3927286
Min length	2

Characters and Unicode

Total characters	729924
Distinct characters	57
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	guas Lindas de Gois
2nd row	guas Lindas de Gois
3rd row	guas Lindas de Gois
4th row	guas Lindas de Gois
5th row	Qomsheh

Value	Count	Frequency (%)
de	1903	1.8%
san	946	0.9%
la	724	0.7%
del	581	0.5%
santa	575	0.5%
el	433	0.4%
hill	404	0.4%
santiago	395	0.4%
plata	353	0.3%
felipe	344	0.3%
Other values (673)	99477	93.7%

Most occurring characters

Value	Count	Frequency (%)
a	108294	14.8%
n	51398	7.0%
o	47215	6.5%
i	45992	6.3%
e	42212	5.8%
r	37947	5.2%
u	33842	4.6%
l	30043	4.1%
s	24579	3.4%
t	24408	3.3%
Other values (47)	283994	38.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	598395	82.0%
Uppercase Letter	105377	14.4%
Space Separator	19164	2.6%
Dash Punctuation	3828	0.5%
Open Punctuation	1501	0.2%
Close Punctuation	1501	0.2%
Other Punctuation	158	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	108294	18.1%
n	51398	8.6%
o	47215	7.9%
i	45992	7.7%
e	42212	7.1%
r	37947	6.3%
u	33842	5.7%
l	30043	5.0%
s	24579	4.1%
t	24408	4.1%
Other values (16)	152465	25.5%

Uppercase Letter

Value	Count	Frequency (%)
S	13137	12.5%
B	9526	9.0%
C	7163	6.8%
A	7133	6.8%
P	6253	5.9%
T	6165	5.9%
K	5864	5.6%
M	5717	5.4%
L	5133	4.9%
H	4290	4.1%
Other values (16)	34996	33.2%

Space Separator

Value	Count	Frequency (%)
	19164	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3828	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1501	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1501	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	158	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	703772	96.4%
Common	26152	3.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	108294	15.4%
n	51398	7.3%
o	47215	6.7%
i	45992	6.5%
e	42212	6.0%
r	37947	5.4%
u	33842	4.8%
l	30043	4.3%
s	24579	3.5%
t	24408	3.5%
Other values (42)	257842	36.6%

Common

Value	Count	Frequency (%)
	19164	73.3%
-	3828	14.6%
(	1501	5.7%
)	1501	5.7%
/	158	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	729924	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	108294	14.8%
n	51398	7.0%
o	47215	6.5%
i	45992	6.3%
e	42212	5.8%
r	37947	5.2%
u	33842	4.6%
l	30043	4.1%
s	24579	3.4%
t	24408	3.3%
Other values (47)	283994	38.9%

country_id
Real number (ℝ)

Distinct	108
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.890297

Minimum	1
Maximum	109
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	679.6 KiB

Quantile statistics

Minimum	1
5-th percentile	12
Q1	29
median	50
Q3	80
95-th percentile	103
Maximum	109
Range	108
Interquartile range (IQR)	51

Descriptive statistics

Standard deviation	30.050282
Coefficient of variation (CV)	0.52821454
Kurtosis	-1.1593477
Mean	56.890297
Median Absolute Deviation (MAD)	27
Skewness	0.054671729
Sum	4947806
Variance	903.01946
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
44	8502	9.8%
23	7638	8.8%
103	5363	6.2%
50	4504	5.2%
60	4469	5.1%
15	4000	4.6%
80	3877	4.5%
75	3100	3.6%
97	2077	2.4%
45	2001	2.3%
Other values (98)	41440	47.6%

Value	Count	Frequency (%)
1	109	0.1%
2	443	0.5%
3	111	0.1%
4	301	0.3%
5	195	0.2%
6	1841	2.1%
7	149	0.2%
9	403	0.5%
10	300	0.3%
11	129	0.1%

Value	Count	Frequency (%)
109	171	0.2%
108	328	0.4%
107	621	0.7%
106	190	0.2%
105	892	1.0%
104	953	1.1%
103	5363	6.2%
102	1188	1.4%
101	474	0.5%
100	823	0.9%

country
Text

Distinct	108
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

Length

Max length	37
Median length	29
Mean length	8.1399892
Min length	4

Characters and Unicode

Total characters	707943
Distinct characters	54
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Brazil
2nd row	Brazil
3rd row	Brazil
4th row	Brazil
5th row	Iran

Value	Count	Frequency (%)
india	8502	8.0%
china	7638	7.2%
united	7025	6.6%
states	5363	5.0%
japan	4504	4.2%
mexico	4469	4.2%
brazil	4000	3.8%
russian	3877	3.6%
federation	3877	3.6%
philippines	3100	2.9%
Other values (122)	54236	50.9%

Most occurring characters

Value	Count	Frequency (%)
a	94530	13.4%
i	79564	11.2%
n	71781	10.1%
e	57603	8.1%
t	35126	5.0%
r	30693	4.3%
d	29861	4.2%
o	26184	3.7%
s	24857	3.5%
l	19770	2.8%
Other values (44)	237974	33.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	581080	82.1%
Uppercase Letter	106019	15.0%
Space Separator	19620	2.8%
Other Punctuation	818	0.1%
Open Punctuation	203	< 0.1%
Close Punctuation	203	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	94530	16.3%
i	79564	13.7%
n	71781	12.4%
e	57603	9.9%
t	35126	6.0%
r	30693	5.3%
d	29861	5.1%
o	26184	4.5%
s	24857	4.3%
l	19770	3.4%
Other values (16)	111111	19.1%

Uppercase Letter

Value	Count	Frequency (%)
I	13788	13.0%
S	11152	10.5%
C	10935	10.3%
U	8038	7.6%
A	6615	6.2%
M	6504	6.1%
P	6468	6.1%
B	5737	5.4%
R	5676	5.4%
T	5413	5.1%
Other values (13)	25693	24.2%

Other Punctuation

Value	Count	Frequency (%)
,	438	53.5%
.	380	46.5%

Space Separator

Value	Count	Frequency (%)
	19620	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	203	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	203	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	687099	97.1%
Common	20844	2.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	94530	13.8%
i	79564	11.6%
n	71781	10.4%
e	57603	8.4%
t	35126	5.1%
r	30693	4.5%
d	29861	4.3%
o	26184	3.8%
s	24857	3.6%
l	19770	2.9%
Other values (39)	217130	31.6%

Common

Value	Count	Frequency (%)
	19620	94.1%
,	438	2.1%
.	380	1.8%
(	203	1.0%
)	203	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	707943	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	94530	13.4%
i	79564	11.2%
n	71781	10.1%
e	57603	8.1%
t	35126	5.0%
r	30693	4.3%
d	29861	4.2%
o	26184	3.7%
s	24857	3.5%
l	19770	2.8%
Other values (44)	237974	33.6%

category
Categorical

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	679.6 KiB

Sports	6861
Animation	6479
Action	6204
Documentary	6139
Drama	5886
Other values (11)	55402

Length

Max length	11
Median length	9
Mean length	6.534339
Min length	3

Characters and Unicode

Total characters	568298
Distinct characters	30
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Family
2nd row	Family
3rd row	Family
4th row	Family
5th row	Music

Common Values

Value	Count	Frequency (%)
Sports	6861	7.9%
Animation	6479	7.4%
Action	6204	7.1%
Documentary	6139	7.1%
Drama	5886	6.8%
Sci-Fi	5695	6.5%
Family	5544	6.4%
Foreign	5516	6.3%
Children	5473	6.3%
New	5131	5.9%
Other values (6)	28043	32.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
sports	6861	7.9%
animation	6479	7.4%
action	6204	7.1%
documentary	6139	7.1%
drama	5886	6.8%
sci-fi	5695	6.5%
family	5544	6.4%
foreign	5516	6.3%
children	5473	6.3%
new	5131	5.9%
Other values (6)	28043	32.2%

Most occurring characters

Value	Count	Frequency (%)
i	56567	10.0%
r	49023	8.6%
o	45518	8.0%
a	44068	7.8%
n	36290	6.4%
e	35971	6.3%
m	33159	5.8%
s	30919	5.4%
c	27520	4.8%
t	25683	4.5%
Other values (20)	183580	32.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	469937	82.7%
Uppercase Letter	92666	16.3%
Dash Punctuation	5695	1.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	56567	12.0%
r	49023	10.4%
o	45518	9.7%
a	44068	9.4%
n	36290	7.7%
e	35971	7.7%
m	33159	7.1%
s	30919	6.6%
c	27520	5.9%
t	25683	5.5%
Other values (9)	85219	18.1%

Uppercase Letter

Value	Count	Frequency (%)
F	16755	18.1%
C	15137	16.3%
A	12683	13.7%
S	12556	13.5%
D	12025	13.0%
N	5131	5.5%
H	4849	5.2%
T	4601	5.0%
G	4490	4.8%
M	4439	4.8%

Dash Punctuation

Value	Count	Frequency (%)
-	5695	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	562603	99.0%
Common	5695	1.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	56567	10.1%
r	49023	8.7%
o	45518	8.1%
a	44068	7.8%
n	36290	6.5%
e	35971	6.4%
m	33159	5.9%
s	30919	5.5%
c	27520	4.9%
t	25683	4.6%
Other values (19)	177885	31.6%

Common

Value	Count	Frequency (%)
-	5695	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	568298	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	56567	10.0%
r	49023	8.6%
o	45518	8.0%
a	44068	7.8%
n	36290	6.4%
e	35971	6.3%
m	33159	5.8%
s	30919	5.4%
c	27520	4.8%
t	25683	4.5%
Other values (20)	183580	32.3%

Interactions

Correlations

	active	actor_id	address_id	amount	category	city_id	country_id	customer_id	film_id	inventory_id	length	payment_id	postal_code	rating	rental_duration	rental_id	rental_rate	replacement_cost	staff_fn	staff_id	staff_ln	store_id
active	1.000	0.000	0.085	0.029	0.032	0.109	0.093	0.093	0.023	0.022	0.029	0.092	0.138	0.015	0.010	0.022	0.007	0.019	0.003	0.003	0.003	0.003
actor_id	0.000	1.000	0.001	-0.007	0.056	0.002	0.002	0.001	0.015	0.015	0.015	0.001	0.003	0.043	0.041	-0.003	0.043	-0.002	0.000	0.000	0.000	0.000
address_id	0.085	0.001	1.000	0.015	0.032	0.041	-0.042	1.000	-0.004	-0.004	-0.015	1.000	-0.043	0.020	0.028	-0.003	0.027	-0.023	0.075	0.075	0.075	0.075
amount	0.029	-0.007	0.015	1.000	0.068	0.001	0.012	0.015	0.027	0.027	0.003	0.015	-0.012	0.033	0.178	0.011	0.716	-0.031	0.018	0.018	0.018	0.018
category	0.032	0.056	0.032	0.068	1.000	0.034	0.030	0.032	0.139	0.138	0.148	0.031	0.029	0.156	0.161	0.024	0.146	0.140	0.032	0.032	0.032	0.032
city_id	0.109	0.002	0.041	0.001	0.034	1.000	-0.058	0.041	0.010	0.010	-0.002	0.041	-0.070	0.020	0.021	-0.004	0.026	-0.001	0.106	0.106	0.106	0.106
country_id	0.093	0.002	-0.042	0.012	0.030	-0.058	1.000	-0.042	0.017	0.017	0.011	-0.042	0.001	0.025	0.022	-0.004	0.020	0.003	0.102	0.102	0.102	0.102
customer_id	0.093	0.001	1.000	0.015	0.032	0.041	-0.042	1.000	-0.004	-0.004	-0.015	1.000	-0.043	0.019	0.029	-0.003	0.027	-0.023	0.074	0.074	0.074	0.074
film_id	0.023	0.015	-0.004	0.027	0.139	0.010	0.017	-0.004	1.000	1.000	0.053	-0.004	-0.008	0.120	0.112	-0.001	0.113	-0.040	0.033	0.033	0.033	0.033
inventory_id	0.022	0.015	-0.004	0.027	0.138	0.010	0.017	-0.004	1.000	1.000	0.053	-0.004	-0.008	0.119	0.112	-0.001	0.116	-0.040	0.032	0.032	0.032	0.032
length	0.029	0.015	-0.015	0.003	0.148	-0.002	0.011	-0.015	0.053	0.053	1.000	-0.015	-0.004	0.101	0.087	0.002	0.105	0.015	0.017	0.017	0.017	0.017
payment_id	0.092	0.001	1.000	0.015	0.031	0.041	-0.042	1.000	-0.004	-0.004	-0.015	1.000	-0.043	0.018	0.028	-0.001	0.026	-0.023	0.073	0.073	0.073	0.073
postal_code	0.138	0.003	-0.043	-0.012	0.029	-0.070	0.001	-0.043	-0.008	-0.008	-0.004	-0.043	1.000	0.016	0.017	0.005	0.027	-0.002	0.091	0.091	0.091	0.091
rating	0.015	0.043	0.020	0.033	0.156	0.020	0.025	0.019	0.120	0.119	0.101	0.018	0.016	1.000	0.096	0.019	0.039	0.112	0.016	0.016	0.016	0.016
rental_duration	0.010	0.041	0.028	0.178	0.161	0.021	0.022	0.029	0.112	0.112	0.087	0.028	0.017	0.096	1.000	0.021	0.072	0.083	0.006	0.006	0.006	0.006
rental_id	0.022	-0.003	-0.003	0.011	0.024	-0.004	-0.004	-0.003	-0.001	-0.001	0.002	-0.001	0.005	0.019	0.021	1.000	0.024	0.006	0.028	0.028	0.028	0.028
rental_rate	0.007	0.043	0.027	0.716	0.146	0.026	0.020	0.027	0.113	0.116	0.105	0.026	0.027	0.039	0.072	0.024	1.000	0.109	0.000	0.000	0.000	0.000
replacement_cost	0.019	-0.002	-0.023	-0.031	0.140	-0.001	0.003	-0.023	-0.040	-0.040	0.015	-0.023	-0.002	0.112	0.083	0.006	0.109	1.000	0.027	0.027	0.027	0.027
staff_fn	0.003	0.000	0.075	0.018	0.032	0.106	0.102	0.074	0.033	0.032	0.017	0.073	0.091	0.016	0.006	0.028	0.000	0.027	1.000	1.000	1.000	1.000
staff_id	0.003	0.000	0.075	0.018	0.032	0.106	0.102	0.074	0.033	0.032	0.017	0.073	0.091	0.016	0.006	0.028	0.000	0.027	1.000	1.000	1.000	1.000
staff_ln	0.003	0.000	0.075	0.018	0.032	0.106	0.102	0.074	0.033	0.032	0.017	0.073	0.091	0.016	0.006	0.028	0.000	0.027	1.000	1.000	1.000	1.000
store_id	0.003	0.000	0.075	0.018	0.032	0.106	0.102	0.074	0.033	0.032	0.017	0.073	0.091	0.016	0.006	0.028	0.000	0.027	1.000	1.000	1.000	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	film_id	title	description	rental_duration	rental_rate	length	replacement_cost	rating	actor_id	actor_fn	actor_ln	customer_id	cust_fn	cust_ln	email	active	rental_id	rental_date	return_date	payment_id	amount	payment_date	inventory_id	store_id	staff_id	staff_fn	staff_ln	address_id	address	postal_code	city_id	city	country_id	country	category
0	80	BLANKET BEVERLY	A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria	7	2.99	148	21.99	G	16	FRED	COSTNER	130	CHARLOTTE	HUNTER	CHARLOTTE.HUNTER@sakilacustomer.org	1	1	2005-05-24 22:53:30.000	2005-05-26 22:04:30.000	3504	2.99	2005-05-24 22:53:30.000	367	1	1	Mike	Hillyer	134	758 Junan Lane	82639	190	guas Lindas de Gois	15	Brazil	Family
1	80	BLANKET BEVERLY	A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria	7	2.99	148	21.99	G	173	ALAN	DREYFUSS	130	CHARLOTTE	HUNTER	CHARLOTTE.HUNTER@sakilacustomer.org	1	1	2005-05-24 22:53:30.000	2005-05-26 22:04:30.000	3504	2.99	2005-05-24 22:53:30.000	367	1	1	Mike	Hillyer	134	758 Junan Lane	82639	190	guas Lindas de Gois	15	Brazil	Family
2	80	BLANKET BEVERLY	A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria	7	2.99	148	21.99	G	193	BURT	TEMPLE	130	CHARLOTTE	HUNTER	CHARLOTTE.HUNTER@sakilacustomer.org	1	1	2005-05-24 22:53:30.000	2005-05-26 22:04:30.000	3504	2.99	2005-05-24 22:53:30.000	367	1	1	Mike	Hillyer	134	758 Junan Lane	82639	190	guas Lindas de Gois	15	Brazil	Family
3	80	BLANKET BEVERLY	A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria	7	2.99	148	21.99	G	200	THORA	TEMPLE	130	CHARLOTTE	HUNTER	CHARLOTTE.HUNTER@sakilacustomer.org	1	1	2005-05-24 22:53:30.000	2005-05-26 22:04:30.000	3504	2.99	2005-05-24 22:53:30.000	367	1	1	Mike	Hillyer	134	758 Junan Lane	82639	190	guas Lindas de Gois	15	Brazil	Family
4	333	FREAKY POCUS	A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico	7	2.99	126	16.99	R	42	TOM	MIRANDA	459	TOMMY	COLLAZO	TOMMY.COLLAZO@sakilacustomer.org	1	2	2005-05-24 22:54:33.000	2005-05-28 19:40:33.000	12377	2.99	2005-05-24 22:54:33.000	1525	1	1	Mike	Hillyer	464	76 Kermanshah Manor	23343	423	Qomsheh	46	Iran	Music
5	333	FREAKY POCUS	A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico	7	2.99	126	16.99	R	103	MATTHEW	LEIGH	459	TOMMY	COLLAZO	TOMMY.COLLAZO@sakilacustomer.org	1	2	2005-05-24 22:54:33.000	2005-05-28 19:40:33.000	12377	2.99	2005-05-24 22:54:33.000	1525	1	1	Mike	Hillyer	464	76 Kermanshah Manor	23343	423	Qomsheh	46	Iran	Music
6	333	FREAKY POCUS	A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico	7	2.99	126	16.99	R	105	SIDNEY	CROWE	459	TOMMY	COLLAZO	TOMMY.COLLAZO@sakilacustomer.org	1	2	2005-05-24 22:54:33.000	2005-05-28 19:40:33.000	12377	2.99	2005-05-24 22:54:33.000	1525	1	1	Mike	Hillyer	464	76 Kermanshah Manor	23343	423	Qomsheh	46	Iran	Music
7	333	FREAKY POCUS	A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico	7	2.99	126	16.99	R	127	KEVIN	GARLAND	459	TOMMY	COLLAZO	TOMMY.COLLAZO@sakilacustomer.org	1	2	2005-05-24 22:54:33.000	2005-05-28 19:40:33.000	12377	2.99	2005-05-24 22:54:33.000	1525	1	1	Mike	Hillyer	464	76 Kermanshah Manor	23343	423	Qomsheh	46	Iran	Music
8	333	FREAKY POCUS	A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico	7	2.99	126	16.99	R	147	FAY	WINSLET	459	TOMMY	COLLAZO	TOMMY.COLLAZO@sakilacustomer.org	1	2	2005-05-24 22:54:33.000	2005-05-28 19:40:33.000	12377	2.99	2005-05-24 22:54:33.000	1525	1	1	Mike	Hillyer	464	76 Kermanshah Manor	23343	423	Qomsheh	46	Iran	Music
9	373	GRADUATE LORD	A Lacklusture Epistle of a Girl And a A Shark who must Meet a Mad Scientist in Ancient China	7	2.99	156	14.99	G	139	EWAN	GOODING	408	MANUEL	MURRELL	MANUEL.MURRELL@sakilacustomer.org	1	3	2005-05-24 23:03:39.000	2005-06-01 22:12:39.000	11032	3.99	2005-05-24 23:03:39.000	1711	1	1	Mike	Hillyer	413	692 Amroha Drive	35575	230	Jaffna	88	Sri Lanka	Children

	film_id	title	description	rental_duration	rental_rate	length	replacement_cost	rating	actor_id	actor_fn	actor_ln	customer_id	cust_fn	cust_ln	email	active	rental_id	rental_date	return_date	payment_id	amount	payment_date	inventory_id	store_id	staff_id	staff_fn	staff_ln	address_id	address	postal_code	city_id	city	country_id	country	category
86961	452	ILLUSION AMELIE	A Emotional Epistle of a Boat And a Mad Scientist who must Outrace a Robot in An Abandoned Mine Shaft	4	0.99	122	15.99	R	133	RICHARD	PENN	114	GRACE	ELLIS	GRACE.ELLIS@sakilacustomer.org	1	16047	2005-08-23 22:42:48.000	2005-08-25 02:48:48.000	3089	0.99	2005-08-23 22:42:48.000	2088	2	2	Jon	Stephens	118	442 Rae Bareli Place	24321	148	Duisburg	38	Germany	Foreign
86962	452	ILLUSION AMELIE	A Emotional Epistle of a Boat And a Mad Scientist who must Outrace a Robot in An Abandoned Mine Shaft	4	0.99	122	15.99	R	184	HUMPHREY	GARLAND	114	GRACE	ELLIS	GRACE.ELLIS@sakilacustomer.org	1	16047	2005-08-23 22:42:48.000	2005-08-25 02:48:48.000	3089	0.99	2005-08-23 22:42:48.000	2088	2	2	Jon	Stephens	118	442 Rae Bareli Place	24321	148	Duisburg	38	Germany	Foreign
86963	439	HUNCHBACK IMPOSSIBLE	A Touching Yarn of a Frisbee And a Dentist who must Fight a Composer in Ancient Japan	4	4.99	151	28.99	PG-13	106	GROUCHO	DUNST	103	GLADYS	HAMILTON	GLADYS.HAMILTON@sakilacustomer.org	1	16048	2005-08-23 22:43:07.000	2005-08-31 21:33:07.000	2799	8.99	2005-08-23 22:43:07.000	2019	1	1	Mike	Hillyer	107	1177 Jelets Way	3305	220	Ilorin	69	Nigeria	Drama
86964	439	HUNCHBACK IMPOSSIBLE	A Touching Yarn of a Frisbee And a Dentist who must Fight a Composer in Ancient Japan	4	4.99	151	28.99	PG-13	175	WILLIAM	HACKMAN	103	GLADYS	HAMILTON	GLADYS.HAMILTON@sakilacustomer.org	1	16048	2005-08-23 22:43:07.000	2005-08-31 21:33:07.000	2799	8.99	2005-08-23 22:43:07.000	2019	1	1	Mike	Hillyer	107	1177 Jelets Way	3305	220	Ilorin	69	Nigeria	Drama
86965	585	MOB DUFFEL	A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies	4	0.99	105	25.99	G	24	CAMERON	STREEP	393	PHILIP	CAUSEY	PHILIP.CAUSEY@sakilacustomer.org	1	16049	2005-08-23 22:50:12.000	2005-08-30 01:01:12.000	10671	3.99	2005-08-23 22:50:12.000	2666	1	1	Mike	Hillyer	398	954 Lapu-Lapu Way	8816	278	Korolev	80	Russian Federation	Drama
86966	585	MOB DUFFEL	A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies	4	0.99	105	25.99	G	31	SISSY	SOBIESKI	393	PHILIP	CAUSEY	PHILIP.CAUSEY@sakilacustomer.org	1	16049	2005-08-23 22:50:12.000	2005-08-30 01:01:12.000	10671	3.99	2005-08-23 22:50:12.000	2666	1	1	Mike	Hillyer	398	954 Lapu-Lapu Way	8816	278	Korolev	80	Russian Federation	Drama
86967	585	MOB DUFFEL	A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies	4	0.99	105	25.99	G	32	TIM	HACKMAN	393	PHILIP	CAUSEY	PHILIP.CAUSEY@sakilacustomer.org	1	16049	2005-08-23 22:50:12.000	2005-08-30 01:01:12.000	10671	3.99	2005-08-23 22:50:12.000	2666	1	1	Mike	Hillyer	398	954 Lapu-Lapu Way	8816	278	Korolev	80	Russian Federation	Drama
86968	585	MOB DUFFEL	A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies	4	0.99	105	25.99	G	61	CHRISTIAN	NEESON	393	PHILIP	CAUSEY	PHILIP.CAUSEY@sakilacustomer.org	1	16049	2005-08-23 22:50:12.000	2005-08-30 01:01:12.000	10671	3.99	2005-08-23 22:50:12.000	2666	1	1	Mike	Hillyer	398	954 Lapu-Lapu Way	8816	278	Korolev	80	Russian Federation	Drama
86969	585	MOB DUFFEL	A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies	4	0.99	105	25.99	G	103	MATTHEW	LEIGH	393	PHILIP	CAUSEY	PHILIP.CAUSEY@sakilacustomer.org	1	16049	2005-08-23 22:50:12.000	2005-08-30 01:01:12.000	10671	3.99	2005-08-23 22:50:12.000	2666	1	1	Mike	Hillyer	398	954 Lapu-Lapu Way	8816	278	Korolev	80	Russian Federation	Drama
86970	585	MOB DUFFEL	A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies	4	0.99	105	25.99	G	106	GROUCHO	DUNST	393	PHILIP	CAUSEY	PHILIP.CAUSEY@sakilacustomer.org	1	16049	2005-08-23 22:50:12.000	2005-08-30 01:01:12.000	10671	3.99	2005-08-23 22:50:12.000	2666	1	1	Mike	Hillyer	398	954 Lapu-Lapu Way	8816	278	Korolev	80	Russian Federation	Drama

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block